DROP TABLE IF EXISTS `USER_`; CREATE TABLE `USER_` (

`USER_FIRSTNAME` VARCHAR(255) DEFAULT NULL,
`USER_LASTNAME` VARCHAR(255) DEFAULT NULL,
`USER_COUNTRY` VARCHAR(255) DEFAULT NULL,
`USER_LEVEL` VARCHAR(255) DEFAULT NULL,
KEY `FK_USER_LEVEL_8` (`USER_LEVEL`),  CONSTRAINT `FK_USER_LEVEL_8` FOREIGN KEY (`USER_LEVEL`) REFERENCES `USER_USER_LEVEL` (`EN`) ON DELETE CASCADE,
`USER_USERNAME` VARCHAR(255) NOT NULL, PRIMARY KEY  (`USER_USERNAME`)) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `A_NEWENTRY_`; CREATE TABLE `A_NEWENTRY_` (

`NEWENTRY_ADMINISTRATIVEDATA` VARCHAR(255) DEFAULT NULL,
`NEWENTRY_SOURCETYPE` VARCHAR(255) DEFAULT NULL,
KEY `FK_NEWENTRY_SOURCETYPE_16` (`NEWENTRY_SOURCETYPE`),  CONSTRAINT `FK_NEWENTRY_SOURCETYPE_16` FOREIGN KEY (`NEWENTRY_SOURCETYPE`) REFERENCES `A_NEWENTRY_NEWENTRY_SOURCETYPE` (`EN`) ON DELETE CASCADE,
`NEWENTRY_LEVEL` VARCHAR(255) DEFAULT NULL,
KEY `FK_NEWENTRY_LEVEL_28` (`NEWENTRY_LEVEL`),  CONSTRAINT `FK_NEWENTRY_LEVEL_28` FOREIGN KEY (`NEWENTRY_LEVEL`) REFERENCES `A_NEWENTRY_NEWENTRY_LEVEL` (`EN`) ON DELETE CASCADE,
`NEWENTRY_REGION` VARCHAR(255) DEFAULT NULL,
`NEWENTRY_REPORTINGDATE` DATE DEFAULT NULL,
`NEWENTRY_YEAROFREFERENCE` INT(10) UNSIGNED DEFAULT NULL,
`NEWENTRY_POLICE_CUSTOMSFILEIDENTIF` VARCHAR(255) DEFAULT NULL,
`NEWENTRY_PUBLICPROSECUTORSFILEIDEN` VARCHAR(255) DEFAULT NULL,
`NEWENTRY_COURTSFILEIDENTIFICATIONN` VARCHAR(255) DEFAULT NULL,
`USER_USERNAME` VARCHAR(255) DEFAULT NULL,
KEY `FK_USER_USERNAME_47` (`USER_USERNAME`),  CONSTRAINT `FK_USER_USERNAME_47` FOREIGN KEY (`USER_USERNAME`) REFERENCES `USER_` (`USER_USERNAME`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `B_1_EVENTS_`; CREATE TABLE `B_1_EVENTS_` (

`ACTIVITIES_RECRUITMENT` TINYINT(1) DEFAULT NULL,
`ACTIVITIES_TRANSPORTATION` TINYINT(1) DEFAULT NULL,
`ACTIVITIES_TRANSFER` TINYINT(1) DEFAULT NULL,
`ACTIVITIES_HARBOURING` TINYINT(1) DEFAULT NULL,
`ACTIVITIES_RECEIPTOFPERSONS` TINYINT(1) DEFAULT NULL,
`RECRUITMENT_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`MANNEROFINITIATIONOFCONTA_PERSONALCONTACT` TINYINT(1) DEFAULT NULL,
`MANNEROFINITIATIONOFCONTA_NEWSPAPERADVERTISEMENT` TINYINT(1) DEFAULT NULL,
`MANNEROFINITIATIONOFCONTA_RADIOADVERTISEMENT` TINYINT(1) DEFAULT NULL,
`MANNEROFINITIATIONOFCONTA_INTERNETADVERTISEMENT` TINYINT(1) DEFAULT NULL,
`MANNEROFINITIATIONOFCONTA_TELEVISIONADVERTISEMENT` TINYINT(1) DEFAULT NULL,
`MANNEROFINITIATIONOFCONTA_SOLDBYFAMILYMEMBER` TINYINT(1) DEFAULT NULL,
`MANNEROFINITIATIONOFCONTA_KIDNAPPED` TINYINT(1) DEFAULT NULL,
`MANNEROFINITIATIONOFCONTA_OTHERALLFIELDSBUTTHESEALR` TINYINT(1) DEFAULT NULL,
`DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION_98` (`DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION`),  CONSTRAINT `FK_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION_98` FOREIGN KEY (`DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION`) REFERENCES `B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION` (`EN`) ON DELETE CASCADE,
`MEANSOFTRANSPORTUSED_CAR` TINYINT(1) DEFAULT NULL,
`MEANSOFTRANSPORTUSED_BUS` TINYINT(1) DEFAULT NULL,
`MEANSOFTRANSPORTUSED_TRAIN` TINYINT(1) DEFAULT NULL,
`MEANSOFTRANSPORTUSED_BOAT` TINYINT(1) DEFAULT NULL,
`MEANSOFTRANSPORTUSED_AIRPLANE` TINYINT(1) DEFAULT NULL,
`MEANSOFTRANSPORTUSED_TRUCK_CONTAINER` TINYINT(1) DEFAULT NULL,
`MEANSOFTRANSPORTUSED_BYFOOT` TINYINT(1) DEFAULT NULL,
`NATIONSCROSSEDDURINGTHETR_COUNTRYOFORIGIN` VARCHAR(255) DEFAULT NULL,
`NATIONSCROSSEDDURINGTHETR_COUNTRYSTRANSITED` VARCHAR(255) DEFAULT NULL,
`NATIONSCROSSEDDURINGTHETR_COUNTRYOFDESTINATION` VARCHAR(255) DEFAULT NULL,
`BORDERSCROSSED_GREENBORDER` VARCHAR(255) DEFAULT NULL,
`BORDERSCROSSED_BLUEBORDER` VARCHAR(255) DEFAULT NULL,
`BORDERSCROSSED_UNKNOWN` VARCHAR(255) DEFAULT NULL,
`EXPLOITATIONINTHETRANSPOR_EXPLOITATIONDURINGTRANSPO` TINYINT(1) DEFAULT NULL,
`EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION_132` (`EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION`),  CONSTRAINT `FK_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION_132` FOREIGN KEY (`EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION`) REFERENCES `B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION` (`EN`) ON DELETE CASCADE,
`PLACESOFHARBOURING_APARTMENT_PRIVATEDWELLING` TINYINT(1) DEFAULT NULL,
`PLACESOFHARBOURING_HOTEL_MOTEL` TINYINT(1) DEFAULT NULL,
`PLACESOFHARBOURING_CAMPINGAREA` TINYINT(1) DEFAULT NULL,
`PLACESOFHARBOURING_PLACEOFEXPLOITATION` TINYINT(1) DEFAULT NULL,
`DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION_146` (`DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION`),  CONSTRAINT `FK_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION_146` FOREIGN KEY (`DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION`) REFERENCES `B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION` (`EN`) ON DELETE CASCADE,
`SEXUALEXPLOITATION_SEXUALEXPLOITATION` TINYINT(1) DEFAULT NULL,
`TYPEOFSEXUALEXPLOITATION_PROSTITUTION` TINYINT(1) DEFAULT NULL,
`TYPEOFSEXUALEXPLOITATION_CHILDPROSTITUTION` TINYINT(1) DEFAULT NULL,
`TYPEOFSEXUALEXPLOITATION_PORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`TYPEOFSEXUALEXPLOITATION_CHILDPORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`TYPEOFSEXUALEXPLOITATION_SEXTOURISM` TINYINT(1) DEFAULT NULL,
`TYPEOFSEXUALEXPLOITATION_OTHER` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_OUTDOOR` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_INDOOR_APARTMENT` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_INDOOR_BROTHEL` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_INDOOR_SAUNA` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_INDOOR_CLUB` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_INDOOR_HOTEL_MOTEL` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_INDOOR_PUB_BAR` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_CALLGIRLS_ESCORTSERVICE` TINYINT(1) DEFAULT NULL,
`PLACEOFSEXUALEXPLOITATION_OTHER` TINYINT(1) DEFAULT NULL,
`LABOUREXPLOITATION_LABOUREXPLOITATION` TINYINT(1) DEFAULT NULL,
`TYPEOFLABOUREXPLOITATION_SLAVERY` TINYINT(1) DEFAULT NULL,
`TYPEOFLABOUREXPLOITATION_COMPULSORYWORK` TINYINT(1) DEFAULT NULL,
`TYPEOFLABOUREXPLOITATION_BONDEDLABOUR` TINYINT(1) DEFAULT NULL,
`SECTOROFLABOUREXPLOITATIO_AGRICULTURE` TINYINT(1) DEFAULT NULL,
`SECTOROFLABOUREXPLOITATIO_INDUSTRY` TINYINT(1) DEFAULT NULL,
`SECTOROFLABOUREXPLOITATIO_COMMERCE` TINYINT(1) DEFAULT NULL,
`SECTOROFLABOUREXPLOITATIO_SERVICES` TINYINT(1) DEFAULT NULL,
`SECTOROFLABOUREXPLOITATIO_PRIVATE` TINYINT(1) DEFAULT NULL,
`SECTOROFLABOUREXPLOITATIO_LEISURE` TINYINT(1) DEFAULT NULL,
`OTHERFORMSOFEXPLOITATION_OTHERFORMSOFEXPLOITATION` TINYINT(1) DEFAULT NULL,
`TYPEOFOTHEREXPLOITATION_BEGGING` TINYINT(1) DEFAULT NULL,
`TYPEOFOTHEREXPLOITATION_LOW_LEVELCRIMINALITY` TINYINT(1) DEFAULT NULL,
`TYPEOFOTHEREXPLOITATION_STREET_SELLING` TINYINT(1) DEFAULT NULL,
`TYPEOFOTHEREXPLOITATION_REMOVALOFORGANS` TINYINT(1) DEFAULT NULL,
`TYPEOFOTHEREXPLOITATION_MILITARYSERVICE` TINYINT(1) DEFAULT NULL,
`TYPEOFOTHEREXPLOITATION_ILLEGALADOPTION` TINYINT(1) DEFAULT NULL,
`TYPEOFOTHEREXPLOITATION_OTHERALLFIELDSBUTTHESEALR` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_RAPE` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_FORGERY` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_FRAUD` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_COUNTERFEITING` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_UNDECLAREDLABOUR` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_KEEPINGABROTHEL` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_BRIBERYOFPUBLICOFFICIALS` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_ILLEGALIMMIGRATION` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_CHILDPORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_SEXUALASSAULT` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_SEXTOURISM` TINYINT(1) DEFAULT NULL,
`ACTCTXTRAFFICKING_OTHER` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_MISUSEOFPOSITIONOROFAPOSI` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_ADMINISTRATIONOFDRUG_MEDI` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_ABDUCTION` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_RESTRICTIONSONFREEDOMOFMO` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_TAKESDOCUMENTSAWAYFROMVIC` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_BYMEANSOFDECEPTION` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_PROMISEOFMARRIAGE_ENGAGEM` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_BYMEANSOFFORCE_THREATOROT` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_THROUGHDEBTBONDAGE` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_GIVINGORRECEIVINGPAYMENTS` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_CONTINUOUSCONTROLOVERTHEV` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_AGREEMENTWITHTHEAUTHOR` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_SALEOFPERSONINTOOWNERSHIP` TINYINT(1) DEFAULT NULL,
`MODUSOPERANDI_OTHERALLFIELDSBUTTHESEALR` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_COLLABORATIONOFMORETHANTW` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_EACHWITHOWNAPPOINTEDTASKS` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_FORAPROLONGEDORINDEFINITE` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_USINGSOMEFORMOFDISCIPLINE` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_SUSPECTEDOFTHECOMMISSIONO` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_OPERATINGONANINTERNATIONA` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_USINGVIOLENCEOROTHERMEANS` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_USINGCOMMERCIALORBUSINESS` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_ENGAGEDINMONEYLAUNDERING` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_EXERTINGINFLUENCEONPOLITI` TINYINT(1) DEFAULT NULL,
`INDICATORSOFORGANISEDCRIM_DETERMINEDBYTHEPURSUITOFP` TINYINT(1) DEFAULT NULL,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_301` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_301` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `B_2_VICTIM_`; CREATE TABLE `B_2_VICTIM_` (

`PERSONALDATA_IDENTITY_NAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_ALIAS` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NICKNAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_SEXOFTHEVICTIM` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_SEXOFTHEVICTIM_313` (`PERSONALDATA_SEXOFTHEVICTIM`),  CONSTRAINT `FK_PERSONALDATA_SEXOFTHEVICTIM_313` FOREIGN KEY (`PERSONALDATA_SEXOFTHEVICTIM`) REFERENCES `B_2_VICTIM_PERSONALDATA_SEXOFTHEVICTIM` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_DATEOFBIRTH` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_COUNTRYOFBIRTH` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_PLACEOFBIRTH` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_NATIONALITY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_FINGERPRINTS` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_CRIMINALRECORD` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_MARITALSTATUS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_MARITALSTATUS_329` (`PERSONALDATA_MARITALSTATUS`),  CONSTRAINT `FK_PERSONALDATA_MARITALSTATUS_329` FOREIGN KEY (`PERSONALDATA_MARITALSTATUS`) REFERENCES `B_2_VICTIM_PERSONALDATA_MARITALSTATUS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI_337` (`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`),  CONSTRAINT `FK_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI_337` FOREIGN KEY (`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`) REFERENCES `B_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_NO_OFCHILDRENOFTHEVICTIM` INT(10) UNSIGNED DEFAULT NULL,
`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_344` (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`),  CONSTRAINT `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_344` FOREIGN KEY (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`) REFERENCES `B_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI_349` (`PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI`),  CONSTRAINT `FK_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI_349` FOREIGN KEY (`PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI`) REFERENCES `B_2_VICTIM_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI` (`EN`) ON DELETE CASCADE,
`LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` VARCHAR(255) DEFAULT NULL,
KEY `FK_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW_356` (`LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW`),  CONSTRAINT `FK_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW_356` FOREIGN KEY (`LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW`) REFERENCES `B_2_VICTIM_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW` (`EN`) ON DELETE CASCADE,
`COUNTRYORRESIDENCEBEFORED_COUNTRYOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` VARCHAR(255) DEFAULT NULL,
KEY `FK_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT_367` (`PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT`),  CONSTRAINT `FK_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT_367` FOREIGN KEY (`PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT`) REFERENCES `B_2_VICTIM_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT` (`EN`) ON DELETE CASCADE,
`INCOME_OCCUPATIONOFTHEVICTIMBEFO` VARCHAR(255) DEFAULT NULL,
KEY `FK_INCOME_OCCUPATIONOFTHEVICTIMBEFO_372` (`INCOME_OCCUPATIONOFTHEVICTIMBEFO`),  CONSTRAINT `FK_INCOME_OCCUPATIONOFTHEVICTIMBEFO_372` FOREIGN KEY (`INCOME_OCCUPATIONOFTHEVICTIMBEFO`) REFERENCES `B_2_VICTIM_INCOME_OCCUPATIONOFTHEVICTIMBEFO` (`EN`) ON DELETE CASCADE,
`ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` VARCHAR(255) DEFAULT NULL,
KEY `FK_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI_382` (`ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI`),  CONSTRAINT `FK_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI_382` FOREIGN KEY (`ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI`) REFERENCES `B_2_VICTIM_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI` (`EN`) ON DELETE CASCADE,
`MOTIVESOFTHEVICTIMTOMIGRA_IMPROVINGECONOMICALSTATUS` TINYINT(1) DEFAULT NULL,
`MOTIVESOFTHEVICTIMTOMIGRA_SEARCHINGABETTERFUTURE` TINYINT(1) DEFAULT NULL,
`MOTIVESOFTHEVICTIMTOMIGRA_POLITICALINSTABILITYINTHE` TINYINT(1) DEFAULT NULL,
`MOTIVESOFTHEVICTIMTOMIGRA_PERSONALRELATIONSHIPWITHT` TINYINT(1) DEFAULT NULL,
`MOTIVESOFTHEVICTIMTOMIGRA_OTHER` TINYINT(1) DEFAULT NULL,
`LIAISONBETWEENTHEVICTIMSA_LIAISON` VARCHAR(255) DEFAULT NULL,
KEY `FK_LIAISONBETWEENTHEVICTIMSA_LIAISON_399` (`LIAISONBETWEENTHEVICTIMSA_LIAISON`),  CONSTRAINT `FK_LIAISONBETWEENTHEVICTIMSA_LIAISON_399` FOREIGN KEY (`LIAISONBETWEENTHEVICTIMSA_LIAISON`) REFERENCES `B_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) ON DELETE CASCADE,
`ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION_409` (`ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION`),  CONSTRAINT `FK_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION_409` FOREIGN KEY (`ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION`) REFERENCES `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION` (`EN`) ON DELETE CASCADE,
`ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION_416` (`ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION`),  CONSTRAINT `FK_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION_416` FOREIGN KEY (`ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION`) REFERENCES `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION` (`EN`) ON DELETE CASCADE,
`ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION_437` (`ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION`),  CONSTRAINT `FK_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION_437` FOREIGN KEY (`ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION`) REFERENCES `B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION` (`EN`) ON DELETE CASCADE,
`MONEYREQUESTED_PAID_VICTIMIS_SOLD_FROMONEGROU` TINYINT(1) DEFAULT NULL,
`MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` VARCHAR(255) DEFAULT NULL,
KEY `FK_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM_448` (`MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM`),  CONSTRAINT `FK_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM_448` FOREIGN KEY (`MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM`) REFERENCES `B_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) ON DELETE CASCADE,
`MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` VARCHAR(255) DEFAULT NULL,
KEY `FK_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS_453` (`MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS`),  CONSTRAINT `FK_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS_453` FOREIGN KEY (`MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS`) REFERENCES `B_2_VICTIM_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS` (`EN`) ON DELETE CASCADE,
`PERSDOCSEIZURE_SEIZUREOFVICTIMSDOCUMENTS` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_WORKPERMIT` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_ASYLUMREQUEST` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_IDENTITYCARD` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_PASSPORT` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_DRIVINGLICENSE` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_VISA` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_BIRTHCERTIFICATE` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_MARRIAGECERTIFICATE` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_ORDERTOLEAVETHECOUNTRY` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_RESIDENCEPERMIT` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_OTHER` TINYINT(1) DEFAULT NULL,
`PERSDOCSEIZURE_NODOCUMENTSUSED` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_USEOFFORGEDDOCUMENTS` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_WORKPERMIT` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_ASYLUMREQUEST` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_IDENTITYCARD` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_PASSPORT` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_DRIVINGLICENSE` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_VISA` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_BIRTHCERTIFICATE` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_MARRIAGECERTIFICATE` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_ORDERTOLEAVETHECOUNTRY` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_RESIDENCEPERMIT` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_OTHER` TINYINT(1) DEFAULT NULL,
`PERSDOCFORGED_NODOCUMENTSUSED` TINYINT(1) DEFAULT NULL,
`RE_VICTIMISATION_RE_VICTIMISATION` TINYINT(1) DEFAULT NULL,
`RE_VICTIMISATION_OFTHESAMECRIME` TINYINT(1) DEFAULT NULL,
`RE_VICTIMISATION_SAMEAREAOFEXPLOITATION` TINYINT(1) DEFAULT NULL,
`RE_VICTIMISATION_AREAOFEXPLOITATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_RE_VICTIMISATION_AREAOFEXPLOITATION_516` (`RE_VICTIMISATION_AREAOFEXPLOITATION`),  CONSTRAINT `FK_RE_VICTIMISATION_AREAOFEXPLOITATION_516` FOREIGN KEY (`RE_VICTIMISATION_AREAOFEXPLOITATION`) REFERENCES `B_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) ON DELETE CASCADE,
`AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` VARCHAR(255) DEFAULT NULL,
KEY `FK_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX_520` (`AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX`),  CONSTRAINT `FK_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX_520` FOREIGN KEY (`AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX`) REFERENCES `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX` (`EN`) ON DELETE CASCADE,
`AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR_526` (`AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR`),  CONSTRAINT `FK_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR_526` FOREIGN KEY (`AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR`) REFERENCES `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR` (`EN`) ON DELETE CASCADE,
`AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` VARCHAR(255) DEFAULT NULL,
KEY `FK_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML_532` (`AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML`),  CONSTRAINT `FK_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML_532` FOREIGN KEY (`AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML`) REFERENCES `B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML` (`EN`) ON DELETE CASCADE,
`AVERAGEINCOMEFROMEXPLOITA_INCOMERECEIVEDFORREMOVALO` TINYINT(1) DEFAULT NULL,
`BACKGROUNDOFVICTIMSCLIENT_LOCALS` TINYINT(1) DEFAULT NULL,
`BACKGROUNDOFVICTIMSCLIENT_INTERNATIONALS` TINYINT(1) DEFAULT NULL,
`BACKGROUNDOFVICTIMSCLIENT_MILITARY` TINYINT(1) DEFAULT NULL,
`BACKGROUNDOFVICTIMSCLIENT_POLICE` TINYINT(1) DEFAULT NULL,
`BACKGROUNDOFVICTIMSCLIENT_CIVILIANS` TINYINT(1) DEFAULT NULL,
`BACKGROUNDOFVICTIMSCLIENT_OTHER` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_POLICE` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_JUDICIALAUTHORITY` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_NGO` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_GO` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_HOSPITALORMEDICALFACILITI` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_INDIVIDUAL` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_HOTLINE` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_OUTREACHSERVICES` TINYINT(1) DEFAULT NULL,
`FIRSTASSISTANCEREFERRAL_OTHERAPPLICABLEWHENNOOTHE` TINYINT(1) DEFAULT NULL,
`INSTITUTIONPROVIDINGASSIS_INSTITUTION` VARCHAR(255) DEFAULT NULL,
KEY `FK_INSTITUTIONPROVIDINGASSIS_INSTITUTION_572` (`INSTITUTIONPROVIDINGASSIS_INSTITUTION`),  CONSTRAINT `FK_INSTITUTIONPROVIDINGASSIS_INSTITUTION_572` FOREIGN KEY (`INSTITUTIONPROVIDINGASSIS_INSTITUTION`) REFERENCES `B_2_VICTIM_INSTITUTIONPROVIDINGASSIS_INSTITUTION` (`EN`) ON DELETE CASCADE,
`KINDOFASSISTANCEPROVIDED_SELFEMPLOYMENT` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_VOCATIONALTRAINING` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_GRANT_SCHEME` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_MICRO_CREDIT` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_JOBREFERRALSUBSIDISEDEMPL` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_EDUCATION` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_LEGALCOUNSELLING` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_MEDICALREFERRALORASSISTAN` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_TEMPORARYRESIDENCEPERMIT` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_COVERINGDOCUMENTS` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_FAMILYSUPPORT` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_HOUSING` TINYINT(1) DEFAULT NULL,
`KINDOFASSISTANCEPROVIDED_SHELTER` TINYINT(1) DEFAULT NULL,
`ASSISTANCEPROVIDEDFORRETU_TEMPORARYSAFEACCOMMODATIO` TINYINT(1) DEFAULT NULL,
`ASSISTANCEPROVIDEDFORRETU_FACILITATIONOFVISA_TRAVEL` TINYINT(1) DEFAULT NULL,
`ASSISTANCEPROVIDEDFORRETU_TRAVELARRANGEMENTS` TINYINT(1) DEFAULT NULL,
`ASSISTANCEPROVIDEDFORRETU_DISBURSEMENTOFATRAVEL_RE_` TINYINT(1) DEFAULT NULL,
`ASSISTANCEPROVIDEDFORRETU_RISKASSESSMENTONORIGINCOU` TINYINT(1) DEFAULT NULL,
`ASSISTANCEPROVIDEDFORRETU_SECURINGOFTEMPORARYDOCUME` TINYINT(1) DEFAULT NULL,
`ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` VARCHAR(255) DEFAULT NULL,
KEY `FK_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO_618` (`ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO`),  CONSTRAINT `FK_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO_618` FOREIGN KEY (`ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO`) REFERENCES `B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO` (`EN`) ON DELETE CASCADE,
`ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` VARCHAR(255) DEFAULT NULL,
KEY `FK_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING_626` (`ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING`),  CONSTRAINT `FK_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING_626` FOREIGN KEY (`ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING`) REFERENCES `B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING` (`EN`) ON DELETE CASCADE,
`INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` VARCHAR(255) DEFAULT NULL,
KEY `FK_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH_632` (`INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH`),  CONSTRAINT `FK_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH_632` FOREIGN KEY (`INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH`) REFERENCES `B_2_VICTIM_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH` (`EN`) ON DELETE CASCADE,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_638` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_638` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `B_3_AUTHOR_`; CREATE TABLE `B_3_AUTHOR_` (

`PERSONALDATA_IDENTITY_NAMEALTERNATIVEL` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_ALIAS` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NICKNAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_PERSONALITYOFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_PERSONALITYOFTHEAUTHOR_651` (`PERSONALDATA_PERSONALITYOFTHEAUTHOR`),  CONSTRAINT `FK_PERSONALDATA_PERSONALITYOFTHEAUTHOR_651` FOREIGN KEY (`PERSONALDATA_PERSONALITYOFTHEAUTHOR`) REFERENCES `B_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_GENDEROFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_GENDEROFTHEAUTHOR_654` (`PERSONALDATA_GENDEROFTHEAUTHOR`),  CONSTRAINT `FK_PERSONALDATA_GENDEROFTHEAUTHOR_654` FOREIGN KEY (`PERSONALDATA_GENDEROFTHEAUTHOR`) REFERENCES `B_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_DATEOFBIRTHOFTHEAUTHOR_DA` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_COUNTRYOFBIRTH_ESTABLISHM` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_PLACEOFBIRTH_ESTABLISHMEN` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_NATIONALITY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_COUNTRYOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_PLACEOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_PLACEOFRESIDENCE_668` (`PERSONALDATA_PLACEOFRESIDENCE`),  CONSTRAINT `FK_PERSONALDATA_PLACEOFRESIDENCE_668` FOREIGN KEY (`PERSONALDATA_PLACEOFRESIDENCE`) REFERENCES `B_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_FINGERPRINTS` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_CRIMINALRECORD` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_RECORDFORTRAFFICKING` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_MARITALSTATUS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_MARITALSTATUS_679` (`PERSONALDATA_MARITALSTATUS`),  CONSTRAINT `FK_PERSONALDATA_MARITALSTATUS_679` FOREIGN KEY (`PERSONALDATA_MARITALSTATUS`) REFERENCES `B_3_AUTHOR_PERSONALDATA_MARITALSTATUS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_687` (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`),  CONSTRAINT `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_687` FOREIGN KEY (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`) REFERENCES `B_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) ON DELETE CASCADE,
`INCOME_OCCUPATIONOFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_INCOME_OCCUPATIONOFTHEAUTHOR_692` (`INCOME_OCCUPATIONOFTHEAUTHOR`),  CONSTRAINT `FK_INCOME_OCCUPATIONOFTHEAUTHOR_692` FOREIGN KEY (`INCOME_OCCUPATIONOFTHEAUTHOR`) REFERENCES `B_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`INCOME_STATUSOFTHEAUTHORTOWARDSI` VARCHAR(255) DEFAULT NULL,
KEY `FK_INCOME_STATUSOFTHEAUTHORTOWARDSI_703` (`INCOME_STATUSOFTHEAUTHORTOWARDSI`),  CONSTRAINT `FK_INCOME_STATUSOFTHEAUTHORTOWARDSI_703` FOREIGN KEY (`INCOME_STATUSOFTHEAUTHORTOWARDSI`) REFERENCES `B_3_AUTHOR_INCOME_STATUSOFTHEAUTHORTOWARDSI` (`EN`) ON DELETE CASCADE,
`ORGANISEDCRIMINALGROUP_THEAUTHORISPARTOFANORGANI` TINYINT(1) DEFAULT NULL,
`ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` VARCHAR(255) DEFAULT NULL,
KEY `FK_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE_710` (`ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE`),  CONSTRAINT `FK_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE_710` FOREIGN KEY (`ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE`) REFERENCES `B_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) ON DELETE CASCADE,
`ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` VARCHAR(255) DEFAULT NULL,
KEY `FK_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN_714` (`ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN`),  CONSTRAINT `FK_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN_714` FOREIGN KEY (`ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN`) REFERENCES `B_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) ON DELETE CASCADE,
`ROLEOFTHEAUTHORINTHECOMMI_RECRUITER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_PASSEUR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_DRIVER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_PREMISESOWNERTHETERMPREMI` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_PHOTOGRAPHER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_IMPRESARIO` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_PIMP` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_DOORWAITER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_MOVIEDIRECTOR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_ENTREPRENEUR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_CONTRACTOR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_MIDDLEMAN` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORINTHECOMMI_OTHER` TINYINT(1) DEFAULT NULL,
`RELATIONSHIPAUTHOR_VICTIM_THEAUTHOROFTRANSPORTATION` TINYINT(1) DEFAULT NULL,
`RELATIONSHIPAUTHOR_VICTIM_NO_OFVICTIMSWITHWHOMTHEAU` TINYINT(1) DEFAULT NULL,
`RELATIONSHIPAUTHOR_VICTIM_THEAUTHORISFELLOWCITIZENW` TINYINT(1) DEFAULT NULL,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_746` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_746` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `C_1_EVENT_`; CREATE TABLE `C_1_EVENT_` (

`EVENTOFCHILDPORNOGRAPHY_EVENTOFCHILDPORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`ECPACTIVITIES_PRODUCTIONOFCHILDPORNOGRA` TINYINT(1) DEFAULT NULL,
`ECPACTIVITIES_DISTRIBUTION_DISSEMINATIO` TINYINT(1) DEFAULT NULL,
`ECPACTIVITIES_VIATHEINTERNET_DISTRIBUTI` TINYINT(1) DEFAULT NULL,
`ECPACTIVITIES_SUPPLYINGORMAKINGAVAILABL` TINYINT(1) DEFAULT NULL,
`ECPACTIVITIES_VIATHEINTERNET_SUPPLYINGO` TINYINT(1) DEFAULT NULL,
`ECPACTIVITIES_ACQUISITIONOFCHILDPORNOGR` TINYINT(1) DEFAULT NULL,
`ECPACTIVITIES_POSSESSIONOFCHILDPORNOGRA` TINYINT(1) DEFAULT NULL,
`ECPDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ECPDURATIONOFTHEEVENT_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ECPDURATIONOFTHEEVENT_DURATION_775` (`ECPDURATIONOFTHEEVENT_DURATION`),  CONSTRAINT `FK_ECPDURATIONOFTHEEVENT_DURATION_775` FOREIGN KEY (`ECPDURATIONOFTHEEVENT_DURATION`) REFERENCES `C_1_EVENT_ECPDURATIONOFTHEEVENT_DURATION` (`EN`) ON DELETE CASCADE,
`ECPCOUNTRYOFTHEEVENT_COUNTRY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ECPMEANSUSEDTOMAKECHILDPO_THEINTERNET` TINYINT(1) DEFAULT NULL,
`ECPMEANSUSEDTOMAKECHILDPO_MAIL_EXPRESSCOURIER` TINYINT(1) DEFAULT NULL,
`ECPMEANSUSEDTOMAKECHILDPO_PERSONALCONTACT` TINYINT(1) DEFAULT NULL,
`ECPSEIZUREOFCHILDPORNOGRA_SEIZUREOFPORNOGRAPHICMEDI` TINYINT(1) DEFAULT NULL,
`ECPSEIZUREOFCHILDPORNOGRA_IDENTIFIEDVICTIMS` TINYINT(1) DEFAULT NULL,
`ECPSEIZUREOFCHILDPORNOGRA_NOTAREALCHILD` TINYINT(1) DEFAULT NULL,
`ECPSEIZUREOFCHILDPORNOGRA_IDENTIFIEDAUTHORWHOISSEXU` TINYINT(1) DEFAULT NULL,
`ECPSEIZUREOFCHILDPORNOGRA_CONVICTEDAUTHOR` TINYINT(1) DEFAULT NULL,
`ECPSEIZUREOFCHILDPORNOGRA_SUSPECTAUTHOR` TINYINT(1) DEFAULT NULL,
`ECPNUMBEROFPICTURESSEIZED_NUMBEROFPICTURESSEIZED` INT(10) UNSIGNED DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_HACKINGCOMPUTERPROTECTION` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_SEXUALASSAULT` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_RAPE` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_CHILDPROSTITUTION` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_UNDECLAREDEMPLOYMENT` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_COUNTERFEITING` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_ABDUCTION` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_KEEPINGABROTHEL` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_TRAFFICKINGINHUMANBEINGS` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_ABUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_ADMINISTRATIONOFDRUGS_MED` TINYINT(1) DEFAULT NULL,
`ECPACTCTXCHILDPRONOGRAPHY_DECEPTIONOFTHEVICTIMINORD` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_VIATHEINTERNET` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_SEXUALINTERCOURSE` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_SEXUALAGGRESSION` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_THROUGHEROTIC_PORNOGRAPHI` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_MISUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_ADMINISTRATIONOFDRUGS` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_ADMINISTRATIONOFMEDICINES` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_TAKESVICTIMAWAY` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_LOCKSVICTIMAWAY_TIESHIM_H` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_BYMEANSOFDECEPTION` TINYINT(1) DEFAULT NULL,
`ECPMODUSOPERANDI_BYMEANSOFFORCE_THREAT` TINYINT(1) DEFAULT NULL,
`EVENTOFSEXUALASSAULT_EVENTOFSEXUALASSAULT` TINYINT(1) DEFAULT NULL,
`ESASEXUALASSAULTDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ESADURATIONOFTHEEVENT_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ESADURATIONOFTHEEVENT_DURATION_855` (`ESADURATIONOFTHEEVENT_DURATION`),  CONSTRAINT `FK_ESADURATIONOFTHEEVENT_DURATION_855` FOREIGN KEY (`ESADURATIONOFTHEEVENT_DURATION`) REFERENCES `C_1_EVENT_ESADURATIONOFTHEEVENT_DURATION` (`EN`) ON DELETE CASCADE,
`ESACOUNTRYOFTHEEVENT_COUNTRYOFTHEEVENT` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ESAACTCTXSEXUALASSAULT_RAPE` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_CHILDPROSTITUTION` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_UNDECLAREDEMPLOYMENT` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_COUNTERFEITING` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_KEEPINGABROTHEL` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_TRAFFICKINGINHUMANBEINGS` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_ABUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_ADMINISTRATIONOFDRUGS_MED` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_ABDUCTION` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_DECEPTIONOFTHEVICTIMINORD` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_CHILDPORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`ESAACTCTXSEXUALASSAULT_BRIBERY` TINYINT(1) DEFAULT NULL,
`ESAMODUSOPERANDI_SEXUALINTERCOURSE` TINYINT(1) DEFAULT NULL,
`ESAMODUSOPERANDI_SEXUALAGGRESSION` TINYINT(1) DEFAULT NULL,
`ESAMODUSOPERANDI_MISUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ESAMODUSOPERANDI_ADMINISTRATIONOFDRUGS_MED` TINYINT(1) DEFAULT NULL,
`ESAMODUSOPERANDI_ABDUCTION` TINYINT(1) DEFAULT NULL,
`ESAMODUSOPERANDI_BYMEANSOFDECEPTION` TINYINT(1) DEFAULT NULL,
`ESAMODUSOPERANDI_BYMEANSOFFORCE_THREAT` TINYINT(1) DEFAULT NULL,
`EVENTOFSEXTOURISM_EVENTOFSEXTOURISM` TINYINT(1) DEFAULT NULL,
`ESTSEXTOURINSMDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ESTDURATIONOFTHEEVENT_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ESTDURATIONOFTHEEVENT_DURATION_912` (`ESTDURATIONOFTHEEVENT_DURATION`),  CONSTRAINT `FK_ESTDURATIONOFTHEEVENT_DURATION_912` FOREIGN KEY (`ESTDURATIONOFTHEEVENT_DURATION`) REFERENCES `C_1_EVENT_ESTDURATIONOFTHEEVENT_DURATION` (`EN`) ON DELETE CASCADE,
`ESTCOUNTRYOFTHEEVENT_COUNTRYOFTHEEVENT` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ESTOFFENCESCOMMITTEDINTHE_RAPE` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_CHILDPROSTITUTION` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_UNDECLAREDEMPLOYMENT` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_COUNTERFEITING` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_LOCKINGUPVICTIM` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_KEEPINGABROTHEL` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_TRAFFICKINGINHUMANBEINGS` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_ABUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_ADMINISTRATIONOFDRUGS_MED` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_ABDUCTION` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_CHILDPORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`ESTOFFENCESCOMMITTEDINTHE_BRIBERY` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_VIATHEINTERNET` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_SEXUALINTERCOURSE` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_SEXUALAGGRESSION` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_PAYMENTFOREACHSERVICE` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_MISUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_ADMINISTRATIONOFDRUGS_MED` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_ABDUCTION` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_BYMEANSOFDECEPTION` TINYINT(1) DEFAULT NULL,
`ESTMODUSOPERANDI_BYMEANSOFFORCE_THREAT` TINYINT(1) DEFAULT NULL,
`EVENTOFCHILDPROSTITUTION_EVENTOFCHILDPROSTITUTION` TINYINT(1) DEFAULT NULL,
`ECPRODATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ECPRODATEOFDURATION_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ECPRODATEOFDURATION_DURATION_971` (`ECPRODATEOFDURATION_DURATION`),  CONSTRAINT `FK_ECPRODATEOFDURATION_DURATION_971` FOREIGN KEY (`ECPRODATEOFDURATION_DURATION`) REFERENCES `C_1_EVENT_ECPRODATEOFDURATION_DURATION` (`EN`) ON DELETE CASCADE,
`ECPROCOUNTRYOFTHEEVENT_COUNTRYOFTHEEVENT` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ECPROOFFENCESCOMMITTEDINT_RAPE` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_UNDECLAREDEMPLOYMENT` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_COUNTERFEITING` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_LOCKINGUPVICTIM` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_KEEPINGABROTHEL` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_TRAFFICKINGINHUMANBEINGS` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_ABUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_ADMINISTRATIONOFDRUGS_MED` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_ABDUCTION` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_CHILDPORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`ECPROOFFENCESCOMMITTEDINT_BRIBERY` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_VIATHEINTERNET` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_SEXUALINTERCOURSE` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_SEXUALAGGRESSION` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_MISUSEOFPOSITION` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_ADMINISTRATIONOFDRUGS` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_ADMINISTRATIONOFMEDICINES` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_TAKESVICTIMAWAY` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_LOCKSVICTIMAWAY_TIESHIM_H` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_BYMEANSOFDECEPTION` TINYINT(1) DEFAULT NULL,
`ECPROMODUSOPERANDI_BYMEANSOFFORCE_THREAT` TINYINT(1) DEFAULT NULL,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_1019` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_1019` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `C_2_VICTIM_`; CREATE TABLE `C_2_VICTIM_` (

`PERSONALDATA_IDENTITY_NAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_ALIAS` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NICKNAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_GENDEROFTHEVICTIM` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_GENDEROFTHEVICTIM_1032` (`PERSONALDATA_GENDEROFTHEVICTIM`),  CONSTRAINT `FK_PERSONALDATA_GENDEROFTHEVICTIM_1032` FOREIGN KEY (`PERSONALDATA_GENDEROFTHEVICTIM`) REFERENCES `C_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_DATEOFBIRTHOFTHEVICTIM` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_AGEOFSEXUALCONSENTINYOURC` INT(10) UNSIGNED DEFAULT NULL,
`PERSONALDATA_VICTIMISUNDERTHEAGEOFCONS` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_COUNTRYOFBIRTH` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_PLACEOFBIRTH` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_NATIONALITY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_FINGERPRINTS` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_CRIMINALRECORD` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_MARITALSTATUS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_MARITALSTATUS_1051` (`PERSONALDATA_MARITALSTATUS`),  CONSTRAINT `FK_PERSONALDATA_MARITALSTATUS_1051` FOREIGN KEY (`PERSONALDATA_MARITALSTATUS`) REFERENCES `C_2_VICTIM_PERSONALDATA_MARITALSTATUS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI_1059` (`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`),  CONSTRAINT `FK_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI_1059` FOREIGN KEY (`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`) REFERENCES `C_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1065` (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`),  CONSTRAINT `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1065` FOREIGN KEY (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`) REFERENCES `C_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI_1070` (`PERSONALDATA_LIVINGSITUATIONOFTHEVICTI`),  CONSTRAINT `FK_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI_1070` FOREIGN KEY (`PERSONALDATA_LIVINGSITUATIONOFTHEVICTI`) REFERENCES `C_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_COUNTRYOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_PLACEOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_PLACEOFRESIDENCE_1079` (`PERSONALDATA_PLACEOFRESIDENCE`),  CONSTRAINT `FK_PERSONALDATA_PLACEOFRESIDENCE_1079` FOREIGN KEY (`PERSONALDATA_PLACEOFRESIDENCE`) REFERENCES `C_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_OCCUPATIONOFTHEVICTIM` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_OCCUPATIONOFTHEVICTIM_1084` (`PERSONALDATA_OCCUPATIONOFTHEVICTIM`),  CONSTRAINT `FK_PERSONALDATA_OCCUPATIONOFTHEVICTIM_1084` FOREIGN KEY (`PERSONALDATA_OCCUPATIONOFTHEVICTIM`) REFERENCES `C_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) ON DELETE CASCADE,
`LIAISONBETWEENTHEVICTIMSA_LIAISON` VARCHAR(255) DEFAULT NULL,
KEY `FK_LIAISONBETWEENTHEVICTIMSA_LIAISON_1094` (`LIAISONBETWEENTHEVICTIMSA_LIAISON`),  CONSTRAINT `FK_LIAISONBETWEENTHEVICTIMSA_LIAISON_1094` FOREIGN KEY (`LIAISONBETWEENTHEVICTIMSA_LIAISON`) REFERENCES `C_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) ON DELETE CASCADE,
`MONEYREQUESTED_PAID_VICTIMIS_SOLD_FROMONEGROU` TINYINT(1) DEFAULT NULL,
`MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` VARCHAR(255) DEFAULT NULL,
KEY `FK_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM_1106` (`MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM`),  CONSTRAINT `FK_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM_1106` FOREIGN KEY (`MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM`) REFERENCES `C_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM` (`EN`) ON DELETE CASCADE,
`RE_VICTIMISATION_RE_VICTIMISATION` TINYINT(1) DEFAULT NULL,
`RE_VICTIMISATION_OFTHESAMECRIME` TINYINT(1) DEFAULT NULL,
`RE_VICTIMISATION_AREAOFEXPLOITATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_RE_VICTIMISATION_AREAOFEXPLOITATION_1116` (`RE_VICTIMISATION_AREAOFEXPLOITATION`),  CONSTRAINT `FK_RE_VICTIMISATION_AREAOFEXPLOITATION_1116` FOREIGN KEY (`RE_VICTIMISATION_AREAOFEXPLOITATION`) REFERENCES `C_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION` (`EN`) ON DELETE CASCADE,
`ATV_FIRSTASSISTANCEREFERR_POLICE` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_JUDICIALAUTHORITY` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_NGO` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_GO` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_HOSPITALORMEDICALFACILITI` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_INDIVIDUAL` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_HOTLINE` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_OUTREACHSERVICES` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_OTHER` TINYINT(1) DEFAULT NULL,
`ATV_INSTITUTIONPROVIDINGA_INSTITUTION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ATV_INSTITUTIONPROVIDINGA_INSTITUTION_1137` (`ATV_INSTITUTIONPROVIDINGA_INSTITUTION`),  CONSTRAINT `FK_ATV_INSTITUTIONPROVIDINGA_INSTITUTION_1137` FOREIGN KEY (`ATV_INSTITUTIONPROVIDINGA_INSTITUTION`) REFERENCES `C_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) ON DELETE CASCADE,
`ATV_KINDOFASSISTANCEPROVI_GRANT_SCHEME` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_EDUCATION` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_LEGALCOUNSELLING` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_MEDICALREFERRALORASSISTAN` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_FAMILYSUPPORT` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_PSYCHOLOGICALASSISTANCE` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_HOUSING` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_SHELTER` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_OTHER` TINYINT(1) DEFAULT NULL,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_1160` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_1160` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `C_3_AUTHOR_`; CREATE TABLE `C_3_AUTHOR_` (

`PERSONALDATA_IDENTITY_NAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_ALIAS` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NICKNAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_PERSONALITYOFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_PERSONALITYOFTHEAUTHOR_1172` (`PERSONALDATA_PERSONALITYOFTHEAUTHOR`),  CONSTRAINT `FK_PERSONALDATA_PERSONALITYOFTHEAUTHOR_1172` FOREIGN KEY (`PERSONALDATA_PERSONALITYOFTHEAUTHOR`) REFERENCES `C_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_GENDEROFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_GENDEROFTHEAUTHOR_1175` (`PERSONALDATA_GENDEROFTHEAUTHOR`),  CONSTRAINT `FK_PERSONALDATA_GENDEROFTHEAUTHOR_1175` FOREIGN KEY (`PERSONALDATA_GENDEROFTHEAUTHOR`) REFERENCES `C_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_DATEOFBIRTHOFTHEAUTHOR` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_COUNTRYOFBIRTH_ESTABLISHM` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_PLACEOFBIRTH_ESTABLISHMEN` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_NATIONALITY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_COUNTRYOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PERSONALDATA_PLACEOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_PLACEOFRESIDENCE_1189` (`PERSONALDATA_PLACEOFRESIDENCE`),  CONSTRAINT `FK_PERSONALDATA_PLACEOFRESIDENCE_1189` FOREIGN KEY (`PERSONALDATA_PLACEOFRESIDENCE`) REFERENCES `C_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_FINGERPRINTS` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_CRIMINALRECORD` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_RECORDFORCHILDPORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_RECORDFORSEXUALASSAULT` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_RECORDFORCHILDPROSTITUTIO` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_RECORDFORSEXTOURISM` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_MARITALSTATUS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_MARITALSTATUS_1206` (`PERSONALDATA_MARITALSTATUS`),  CONSTRAINT `FK_PERSONALDATA_MARITALSTATUS_1206` FOREIGN KEY (`PERSONALDATA_MARITALSTATUS`) REFERENCES `C_3_AUTHOR_PERSONALDATA_MARITALSTATUS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1214` (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`),  CONSTRAINT `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1214` FOREIGN KEY (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`) REFERENCES `C_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) ON DELETE CASCADE,
`INCOME_OCCUPATIONOFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_INCOME_OCCUPATIONOFTHEAUTHOR_1219` (`INCOME_OCCUPATIONOFTHEAUTHOR`),  CONSTRAINT `FK_INCOME_OCCUPATIONOFTHEAUTHOR_1219` FOREIGN KEY (`INCOME_OCCUPATIONOFTHEAUTHOR`) REFERENCES `C_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`ORGANISEDCRIMINALGROUP_THEAUTHORISPARTOFANORGANI` TINYINT(1) DEFAULT NULL,
`ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` VARCHAR(255) DEFAULT NULL,
KEY `FK_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE_1235` (`ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE`),  CONSTRAINT `FK_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE_1235` FOREIGN KEY (`ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE`) REFERENCES `C_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE` (`EN`) ON DELETE CASCADE,
`ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` VARCHAR(255) DEFAULT NULL,
KEY `FK_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN_1239` (`ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN`),  CONSTRAINT `FK_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN_1239` FOREIGN KEY (`ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN`) REFERENCES `C_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN` (`EN`) ON DELETE CASCADE,
`ROLEOFTHEAUTHORCOMMISSION_RECRUITER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_PASSEUR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_DRIVER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_PREMISESOWNERTHETERMPREMI` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_PHOTOGRAPHER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_IMPRESARIO` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_FACILITATOR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_DOORWAITER` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_MOVIEDIRECTOR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_DISTRIBUTOR_SELLEROFCHILD` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_RECEIVER_PURCHASEROFCHILD` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_MIDDLEMAN` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_CONTRACTOR` TINYINT(1) DEFAULT NULL,
`ROLEOFTHEAUTHORCOMMISSION_OTHER` TINYINT(1) DEFAULT NULL,
`RELATIONSHIPAUTHOR_VICTIM_NO_OFVICTIMSWITHWHOMTHEAU` INT(10) UNSIGNED DEFAULT NULL,
`RELATIONSHIPAUTHOR_VICTIM_THEAUTHORISFELLOWCITIZENW` TINYINT(1) DEFAULT NULL,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_1270` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_1270` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `D_1_EVENT_`; CREATE TABLE `D_1_EVENT_` (

`RUNAWAYS_` TINYINT(1) DEFAULT NULL,
`RUNAWAYSDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`RUNAWAYSDURATIONOFTHEEVEN_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_RUNAWAYSDURATIONOFTHEEVEN_DURATION_1284` (`RUNAWAYSDURATIONOFTHEEVEN_DURATION`),  CONSTRAINT `FK_RUNAWAYSDURATIONOFTHEEVEN_DURATION_1284` FOREIGN KEY (`RUNAWAYSDURATIONOFTHEEVEN_DURATION`) REFERENCES `D_1_EVENT_RUNAWAYSDURATIONOFTHEEVEN_DURATION` (`EN`) ON DELETE CASCADE,
`RUNAWAYSCOUNTRYWHERETHEEV_COUNTRY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`RUNAWAYSCOUNTRIESOFACCOMM_COUNTRIES` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`RUNAWAYSPLACE_PERSONWHERE_PARENTS` TINYINT(1) DEFAULT NULL,
`RUNAWAYSPLACE_PERSONWHERE_MOTHER` TINYINT(1) DEFAULT NULL,
`RUNAWAYSPLACE_PERSONWHERE_FATHER` TINYINT(1) DEFAULT NULL,
`RUNAWAYSPLACE_PERSONWHERE_FAMILYMEMBER` TINYINT(1) DEFAULT NULL,
`RUNAWAYSPLACE_PERSONWHERE_FOSTERPARENTS` TINYINT(1) DEFAULT NULL,
`RUNAWAYSPLACE_PERSONWHERE_INSTITUTION` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_CAR` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_BUS` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_TRAIN` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_BOAT` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_AIRPLANE` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_TRUCK_CONTAINER` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_BYFOOT` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_BICYCLE` TINYINT(1) DEFAULT NULL,
`RUNAWAYSMEANSOFTRANSPORTU_MOTORBIKEORMOTORCYCLE` TINYINT(1) DEFAULT NULL,
`ABDUCTIONBYATHIRDPERSON_ABDUCTIONBYATHIRDPERSON` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ABDUCTI3RDPERSONDURATIONO_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ABDUCTI3RDPERSONDURATIONO_DURATION_1327` (`ABDUCTI3RDPERSONDURATIONO_DURATION`),  CONSTRAINT `FK_ABDUCTI3RDPERSONDURATIONO_DURATION_1327` FOREIGN KEY (`ABDUCTI3RDPERSONDURATIONO_DURATION`) REFERENCES `D_1_EVENT_ABDUCTI3RDPERSONDURATIONO_DURATION` (`EN`) ON DELETE CASCADE,
`ABDUCTI3RDPERSONCOUNTRYWH_COUNTRY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ABDUCTI3RDPERSONCOUNTRIES_COUNTRIES` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`ABDUCTI3RDPERSONACTIVITIE_SIMPLEABDUCTION` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONACTIVITIE_ABDUCTIONBYFORCE_THREATOF` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONACTIVITIE_PUTSTHEVICTIMINDANGEROFDE` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONACTIVITIE_THEACTCAUSESTHEDEATHOFTHE` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONACTIVITIE_THEAUTHORENRICHESHIMSELF` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_CAR` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_BUS` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_TRAIN` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_BOAT` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_AIRPLANE` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_TRUCK_CONTAINER` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_BYFOOT` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_BICYCLE` TINYINT(1) DEFAULT NULL,
`ABDUCTI3RDPERSONMEANSOFTR_MOTORBIKEORMOTORCYCLE` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTION_PARENTALABDUCTION` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PARENTALABDUCTDURATIONOFT_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_PARENTALABDUCTDURATIONOFT_DURATION_1364` (`PARENTALABDUCTDURATIONOFT_DURATION`),  CONSTRAINT `FK_PARENTALABDUCTDURATIONOFT_DURATION_1364` FOREIGN KEY (`PARENTALABDUCTDURATIONOFT_DURATION`) REFERENCES `D_1_EVENT_PARENTALABDUCTDURATIONOFT_DURATION` (`EN`) ON DELETE CASCADE,
`PARENTALABDUCTCOUNTRYWHER_COUNTRY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PARENTALABDUCTCOUNTRIESOF_COUNTRIES` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PARENTALABDUCTACTIVITIESC_SIMPLEABDUCTION` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTACTIVITIESC_ABDUCTIONBYFORCE_THREATOF` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTACTIVITIESC_PUTSTHEVICTIMINDANGEROFDE` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTACTIVITIESC_THEACTCAUSESTHEDEATHOFTHE` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTACTIVITIESC_THEAUTHORENRICHESHIMSELF` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_CAR` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_BUS` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_TRAIN` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_BOAT` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_AIRPLANE` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_TRUCK_CONTAINER` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_BYFOOT` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_BICYCLE` TINYINT(1) DEFAULT NULL,
`PARENTALABDUCTMEANSOFTRAN_MOTORBIKEORMOTORCYCLE` TINYINT(1) DEFAULT NULL,
`LOST_INJUREDOROTHERWISEMI_` TINYINT(1) DEFAULT NULL,
`LOSTINFUREDMISSDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`LOSTINFUREDMISSDURATIONOF_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_LOSTINFUREDMISSDURATIONOF_DURATION_1401` (`LOSTINFUREDMISSDURATIONOF_DURATION`),  CONSTRAINT `FK_LOSTINFUREDMISSDURATIONOF_DURATION_1401` FOREIGN KEY (`LOSTINFUREDMISSDURATIONOF_DURATION`) REFERENCES `D_1_EVENT_LOSTINFUREDMISSDURATIONOF_DURATION` (`EN`) ON DELETE CASCADE,
`LOSTINFUREDMISSCOUNTRYWHE_COUNTRY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`LOSTINFUREDMISSCOUNTRIESO_COUNTRIES` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`PLACEWHERETHECHILDGOTLOST_CITY` TINYINT(1) DEFAULT NULL,
`PLACEWHERETHECHILDGOTLOST_SCHOOL` TINYINT(1) DEFAULT NULL,
`PLACEWHERETHECHILDGOTLOST_VACATION` TINYINT(1) DEFAULT NULL,
`PLACEWHERETHECHILDGOTLOST_FOREIGNCOUNTRY` TINYINT(1) DEFAULT NULL,
`PLACEWHERETHECHILDGOTLOST_YOUTHCAMP` TINYINT(1) DEFAULT NULL,
`PLACEWHERETHECHILDGOTLOST_OTHERCROWDEDPLACES` TINYINT(1) DEFAULT NULL,
`MISSINGUNACCOMPANIEDMIGRA_MISSINGUNACCOMPANIEDMIGRA` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGDATE_PERIODOFTHEEVENT` DATE DEFAULT NULL,
`MISSUNACMIGDURATIONOFTHEE_DURATION` VARCHAR(255) DEFAULT NULL,
KEY `FK_MISSUNACMIGDURATIONOFTHEE_DURATION_1426` (`MISSUNACMIGDURATIONOFTHEE_DURATION`),  CONSTRAINT `FK_MISSUNACMIGDURATIONOFTHEE_DURATION_1426` FOREIGN KEY (`MISSUNACMIGDURATIONOFTHEE_DURATION`) REFERENCES `D_1_EVENT_MISSUNACMIGDURATIONOFTHEE_DURATION` (`EN`) ON DELETE CASCADE,
`MISSUNACMIGCOUNTRYOFTHEEV_COUNTRY` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`MISSUNACMIGCOUNTRIESOFACC_COUNTRIES` VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
`MISSUNACMIGPERSONALDOCUME_SEIZUREOFVICTIMSDOCUMENTS` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_WORKPERMIT` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_ASYLUMREQUEST` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_IDENTITYCARD` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_PASSPORT` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_DRIVINGLICENSE` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_VISA` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_BIRTHCERTIFICATE` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_MARRIAGECERTIFICATE` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_ORDERTOLEAVETHECOUNTRY` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_RESIDENCEPERMIT` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_OTHER` TINYINT(1) DEFAULT NULL,
`MISSUNACMIGPERSONALDOCUME_NODOCUMENTSUSED` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_USEOFFORGEDDOCUMENTS` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_WORKPERMIT` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_ASYLUMREQUEST` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_IDENTITYCARD` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_PASSPORT` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_DRIVINGLICENSE` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_VISA` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_BIRTHCERTIFICATE` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_MARRIAGECERTIFICATE` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_ORDERTOLEAVETHECOUNTRY` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_RESIDENCEPERMIT` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_OTHER` TINYINT(1) DEFAULT NULL,
`PERSONALDOCUMENTSFORGED_NODOCUMENTSUSED` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_TRAFFICKINGINHUMANBEINGS` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_RAPE` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_FORGERY` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_BRIBERY` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_KIDNAPPING` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_LOCKINGUPOFPERSONS` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_SEXUALASSAULT` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_SEXTOURISM` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_PROSTITUTION` TINYINT(1) DEFAULT NULL,
`ACTSCOMMITINTHECTXOFMISSI_PORNOGRAPHY` TINYINT(1) DEFAULT NULL,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_1510` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_1510` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `D_2_VICTIM_`; CREATE TABLE `D_2_VICTIM_` (

`PERSONALDATA_IDENTITY_NAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_ALIAS` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NICKNAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_GENDEROFTHEVICTIM` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_GENDEROFTHEVICTIM_1524` (`PERSONALDATA_GENDEROFTHEVICTIM`),  CONSTRAINT `FK_PERSONALDATA_GENDEROFTHEVICTIM_1524` FOREIGN KEY (`PERSONALDATA_GENDEROFTHEVICTIM`) REFERENCES `D_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_DATEOFBIRTH` DATE DEFAULT NULL,
`PERSONALDATA_COUNTRYOFBIRTH` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_PLACEOFBIRTH` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NATIONALITY` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_FINGERPRINTS` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_CRIMINALRECORD` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_MARITALSTATUS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_MARITALSTATUS_1540` (`PERSONALDATA_MARITALSTATUS`),  CONSTRAINT `FK_PERSONALDATA_MARITALSTATUS_1540` FOREIGN KEY (`PERSONALDATA_MARITALSTATUS`) REFERENCES `D_2_VICTIM_PERSONALDATA_MARITALSTATUS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI_1548` (`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`),  CONSTRAINT `FK_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI_1548` FOREIGN KEY (`PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI`) REFERENCES `D_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1554` (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`),  CONSTRAINT `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1554` FOREIGN KEY (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`) REFERENCES `D_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI_1559` (`PERSONALDATA_LIVINGSITUATIONOFTHEVICTI`),  CONSTRAINT `FK_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI_1559` FOREIGN KEY (`PERSONALDATA_LIVINGSITUATIONOFTHEVICTI`) REFERENCES `D_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT_1568` (`PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT`),  CONSTRAINT `FK_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT_1568` FOREIGN KEY (`PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT`) REFERENCES `D_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_OCCUPATIONOFTHEVICTIM` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_OCCUPATIONOFTHEVICTIM_1573` (`PERSONALDATA_OCCUPATIONOFTHEVICTIM`),  CONSTRAINT `FK_PERSONALDATA_OCCUPATIONOFTHEVICTIM_1573` FOREIGN KEY (`PERSONALDATA_OCCUPATIONOFTHEVICTIM`) REFERENCES `D_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM` (`EN`) ON DELETE CASCADE,
`LIAISONBETWEENTHEVICTIMSA_LIAISON` VARCHAR(255) DEFAULT NULL,
KEY `FK_LIAISONBETWEENTHEVICTIMSA_LIAISON_1586` (`LIAISONBETWEENTHEVICTIMSA_LIAISON`),  CONSTRAINT `FK_LIAISONBETWEENTHEVICTIMSA_LIAISON_1586` FOREIGN KEY (`LIAISONBETWEENTHEVICTIMSA_LIAISON`) REFERENCES `D_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON` (`EN`) ON DELETE CASCADE,
`RE_VICTIMISATION_RE_VICTIMISATION` TINYINT(1) DEFAULT NULL,
`RE_VICTIMISATION_OFTHESAMECRIME` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_POLICE` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_JUDICIALAUTHORITY` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_NGO` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_GO` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_INDIVIDUAL` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_HOTLINE` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_OUTREACHSERVICES` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_HOSPITALORMEDICALFACILITI` TINYINT(1) DEFAULT NULL,
`ATV_FIRSTASSISTANCEREFERR_OTHERAPPLICABLEWHENNOOTHE` VARCHAR(255) DEFAULT NULL,
`ATV_INSTITUTIONPROVIDINGA_INSTITUTION` VARCHAR(255) DEFAULT NULL,
KEY `FK_ATV_INSTITUTIONPROVIDINGA_INSTITUTION_1615` (`ATV_INSTITUTIONPROVIDINGA_INSTITUTION`),  CONSTRAINT `FK_ATV_INSTITUTIONPROVIDINGA_INSTITUTION_1615` FOREIGN KEY (`ATV_INSTITUTIONPROVIDINGA_INSTITUTION`) REFERENCES `D_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION` (`EN`) ON DELETE CASCADE,
`ATV_KINDOFASSISTANCEPROVI_SELFEMPLOYMENT` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_GRANT_SCHEME` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_MICRO_CREDIT` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_JOBREFERRALSUBSIDISEDEMPL` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_EDUCATION` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_LEGALCOUNSELLING` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_MEDICALREFERRALORASSISTAN` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_FAMILYSUPPORT` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_PSYCHOLOGICALASSISTANCE` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_HOUSING` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_SHELTER` TINYINT(1) DEFAULT NULL,
`ATV_KINDOFASSISTANCEPROVI_OTHER` VARCHAR(255) DEFAULT NULL,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_1643` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_1643` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
DROP TABLE IF EXISTS `D_3_AUTHOR_`; CREATE TABLE `D_3_AUTHOR_` (

`PERSONALDATA_IDENTITY_NAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_ALIAS` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NICKNAME` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_GENDEROFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_GENDEROFTHEAUTHOR_1657` (`PERSONALDATA_GENDEROFTHEAUTHOR`),  CONSTRAINT `FK_PERSONALDATA_GENDEROFTHEAUTHOR_1657` FOREIGN KEY (`PERSONALDATA_GENDEROFTHEAUTHOR`) REFERENCES `D_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_DATEOFBIRTH` DATE DEFAULT NULL,
`PERSONALDATA_COUNTRYOFBIRTH` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_PLACEOFBIRTH` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_NATIONALITY` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_COUNTRYOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
`PERSONALDATA_PLACEOFRESIDENCE` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_PLACEOFRESIDENCE_1671` (`PERSONALDATA_PLACEOFRESIDENCE`),  CONSTRAINT `FK_PERSONALDATA_PLACEOFRESIDENCE_1671` FOREIGN KEY (`PERSONALDATA_PLACEOFRESIDENCE`) REFERENCES `D_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_FINGERPRINTS` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_CRIMINALRECORD` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_RECORDFORABDUCTION` TINYINT(1) DEFAULT NULL,
`PERSONALDATA_MARITALSTATUS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_MARITALSTATUS_1682` (`PERSONALDATA_MARITALSTATUS`),  CONSTRAINT `FK_PERSONALDATA_MARITALSTATUS_1682` FOREIGN KEY (`PERSONALDATA_MARITALSTATUS`) REFERENCES `D_3_AUTHOR_PERSONALDATA_MARITALSTATUS` (`EN`) ON DELETE CASCADE,
`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` VARCHAR(255) DEFAULT NULL,
KEY `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1690` (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`),  CONSTRAINT `FK_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS_1690` FOREIGN KEY (`PERSONALDATA_EDUCATIONINCLUDESPRIMARYS`) REFERENCES `D_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS` (`EN`) ON DELETE CASCADE,
`INCOME_OCCUPATIONOFTHEAUTHOR` VARCHAR(255) DEFAULT NULL,
KEY `FK_INCOME_OCCUPATIONOFTHEAUTHOR_1695` (`INCOME_OCCUPATIONOFTHEAUTHOR`),  CONSTRAINT `FK_INCOME_OCCUPATIONOFTHEAUTHOR_1695` FOREIGN KEY (`INCOME_OCCUPATIONOFTHEAUTHOR`) REFERENCES `D_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR` (`EN`) ON DELETE CASCADE,
`A_NEWENTRY_ID` BIGINT(20) DEFAULT NULL,
KEY `FK_A_NEWENTRY_ID_1708` (`A_NEWENTRY_ID`),  CONSTRAINT `FK_A_NEWENTRY_ID_1708` FOREIGN KEY (`A_NEWENTRY_ID`) REFERENCES `A_NEWENTRY_` (`ID`) ON DELETE CASCADE,
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY  (`ID`), `DIGEST` VARCHAR(255) DEFAULT NULL) ENGINE=INNODB DEFAULT CHARSET=LATIN1;
